Request a Demo
Home   >   mailing lists

Re: IS it a good practice to use SERIAL as Primary Key? - Mailing list pgsql-general

From Scott Ribe
Subject Re: IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id C190A0AD.5C28D%scott_ribe@killerbytes.com
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
> OK, let's use a synthetic key on the sales master table.  In fact,
> *both* companies have a synthetic key on their sales master tables.
>
> OMG, conflicting/overlapping synthetic keys!!!!!

Which are not exposed in any UI and therefore easier to change?

Heck, I'd use UUIDs everywhere if it weren't such a pain in the neck to type
them into queries.

--
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Next
From: John McCawley
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?